﻿CREATE PROCEDURE [dbo].[proc_Finance_Bank_GetItem]
	(
		@BId uniqueidentifier
	)
AS
	Select
	Id,
	BId,
	TypeId,
	IsNull((Select Title From Finance_Bank_Type Where Id=Finance_Bank.TypeId),'...') As BankType,
	InitialMoney,
	CompanyId,
	IsNull((Select CompanyName From Company Where Id=Finance_Bank.CompanyId),'...') As Company,
	OpenBank,
	AccountName,
	AccountCartId,
	CreateDate,
	UserName,PaymentTypeId, PaymentTypeName
	From Finance_Bank Where BId=@BId
	RETURN
